package com.zzc.repository;

import com.zzc.domain.ProductDetail;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.ArrayList;

public interface ProductDetailRep extends JpaRepository<ProductDetail,Integer> {
    @Query(value = "select * from PRODUCTDETAIL WHERE PRODUCT_NAME = ?1",nativeQuery = true)
    ArrayList<ProductDetail> finDetailByProductName(String prodName);
}
